class RoleMapper:
    GET_ROLE = """SELECT `role_id` FROM `aoa_role_` WHERE role_name='{role}'"""
    
    ADD_ROLE = """INSERT INTO `aoa_role_`(`role_id`,`role_name`, `role_value`) VALUES ({role_id},'{role}',0)"""

    ROLE_ID_LIST = """SELECT `role_id` FROM `aoa_role_`"""
    
    INSERT_ROLE_LIST = """INSERT INTO `aoa_role_power_list`(`is_show`,`menu_id`,`role_id`) VALUES (1,{menu_id},{role_id})"""